lower

lower

Description

Syntax:

VARCHAR lower (VARCHAR str)

This function de-capitalizes all characters in the string.

Example

mysql> SELECT lower("AbC123");
+-----------------+
| lower('AbC123') |
+-----------------+
| abc123          |
+-----------------+

Keywords

LOWER